﻿CREATE TABLE [dbo].[DimCustomer](
	[CustomerId] [int] identity(1,1),
	[CustomerCode] [int] NOT NULL,
	[FirstName] [nvarchar](40) NULL ,
	[LastName] [nvarchar](20) NULL ,
	[Company] [nvarchar](80) NULL ,
	[Address] [nvarchar](70) NULL,
	[City] [nvarchar](40) NULL ,
	[State] [nvarchar](40) NULL ,
	[Country] [nvarchar](40) NULL ,
	[PostalCode] [nvarchar](10) NULL,
	[Phone] [nvarchar](24) NULL,
	[Fax] [nvarchar](24) NULL,
	[Email] [nvarchar](60) NULL,
 [TaskExecutionLogId] INT NOT NULL DEFAULT 0, 
    [SCDEffectiveFrom] DATETIME NULL , 
    [SCDEffectiveTo] DATETIME NULL , 
    CONSTRAINT [PK_DimCustomer] PRIMARY KEY CLUSTERED 
(
	[CustomerId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
